/*
 Navicat MySQL Data Transfer

 Source Server         : lenovo
 Source Server Type    : MySQL
 Source Server Version : 50725 (5.7.25-log)
 Source Host           : 192.168.3.13:3306
 Source Schema         : im_unitree

 Target Server Type    : MySQL
 Target Server Version : 50725 (5.7.25-log)
 File Encoding         : 65001

 Date: 28/08/2023 10:56:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for community
-- ----------------------------
DROP TABLE IF EXISTS `community`;
CREATE TABLE `community` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `ownerid` bigint(20) DEFAULT NULL,
  `icon` varchar(250) DEFAULT NULL,
  `cate` int(11) DEFAULT NULL,
  `memo` varchar(120) DEFAULT NULL,
  `createat` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of community
-- ----------------------------
BEGIN;
INSERT INTO `community` (`id`, `name`, `ownerid`, `icon`, `cate`, `memo`, `createat`) VALUES (1, '小林家的龙女仆', 1, '/mnt/16931415671374986871.jpeg', 0, '小林家庭会议', '2023-08-27 21:06:22');
INSERT INTO `community` (`id`, `name`, `ownerid`, `icon`, `cate`, `memo`, `createat`) VALUES (2, '此经如此深奥', 1, '/mnt/16931417932080350265.jpg', 4, '整点薯条', '2023-08-27 21:10:25');
INSERT INTO `community` (`id`, `name`, `ownerid`, `icon`, `cate`, `memo`, `createat`) VALUES (3, '开学前的挣扎', 2, '/mnt/1693156987726303455.jpeg', 0, '', '2023-08-28 01:23:17');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
